Customer Preferences - FIL 38
How the System Reads the Customer Preferences File
Customer Preference Print Options
Customer Preferences Item Cross Reference Screen
Customer Preferences Unit of Measure (UOM) Table
Customer Preferences Roll Sizes Screen
The Customer/Item Messages Screen
Assigning Preferred Serial Numbers
You can use the Customer Preferences File to activate many special functions and preferences for specific customer accounts. You can also specify these preferences by chain.
From the Customer Preferences File you can:
- Set up a cross reference file of the customer's own item numbers. This cross reference file can then be used in Order Entry and printed on the customer's invoices and pick lists.
- Set up a table of customers' preferred units of measure for your products. For example, you can specify that, for certain products you sell by the square foot, customers sees the unit of measure expressed on their invoices in pieces.
- Set up a table of preferred roll sizes. Customers who stock rolled goods, might have racks with size limits, or they might simply prefer certain sizes.
- Set up rules and guidelines for the processing of the customer orders, labels, EDI, and invoices.
How the System Reads the Customer Preferences File
When a customer preference function is applicable, the system first checks for a customer preference entry by account number. If the customer belongs to a chain, the system then checks by chain code. If a preference exists for both the account and the chain, the account preference is used. However, this logic is applied on a feature-by-feature basis for the customer item number, customer unit of measure, and customer roll sizes features. For example, if on an account number level, a customer has his own unit of measure preferences table, but no item number table, and the same customer has an item number table for its chain, the system uses the account number level unit of measure table and the chain level item number table.
Field Name |
Description/Instructions |
Default Order Handling/Back Order Code |
Enter an order handling code for this customer or chain.
Order handling code 1 has a back order code of 1 at the time of invoicing.
Order handling code 2 has a back order code of 2 at the time of invoicing.
Order handling code 3 has a back order code of 1 at the time of invoicing.
Order handling code 4 has a back order code of 1 at the time of invoicing.
Order handling code 5 has a back order code of 2 at the time of invoicing.
Order handling code 6 has a back order code of 1 at the time of invoicing.
Order handling code 7 has a back order code of 1 at the time of invoicing.
Order handling code 8 has a back order code of 1 at the time of invoicing. Order handling codes, and the cancellation and billing of individual line items can be overridden or determined when you create orders and invoices. The order handling code provides the default method of handling unless overridden. |
Purchase Order Number Edit Mask |
Enter a string of characters that represent the format of the customer's purchase order as follows: @ - alphanumeric character & - alphanumeric character or blank * - alphanumeric character or null # - numeric digit $ - numeric digit or blank % - numeric digit or null A null indicates an unused space as opposed to a blank, which is a space containing a blank character. Any other character specified indicates that character must appear on the purchase order in that position. For example, if the mask is AB###-@&&, it indicates the purchase order number must begin with AB, followed by a three-digit number, then a dash, and then one to three characters. All customer service personnel must be aware of how to read these edit masks. If someone enters an invalid customer purchase order for a customer with a purchase order edit mask, the system displays an error message and the required mask. Once a purchase order edit mask is established for a customer or chain, the system automatically checks for duplicate purchase orders and alerts order entry operators. This field controls the amount of characters that can be entered in the Customer PO number field in order entry. To use 24 characters to enter a PO, ensure that this field is set-up correctly with more than 12 characters (i.e., #####$$##@@@@). The extended PO# field is primarily for EDI relationships where the customer's PO number includes accounting codes and store numbers. |
Purchase Order Number Edit Examples |
Following are examples:
|
For trailing characters, there is no functional difference between using mask characters that represent blanks versus nulls. There is only a difference when there are additional mask characters to the right of a blank or null mask character. A blank character takes one space. A null takes no space. |
|
Preferred UCC/EAN-128 Label Format |
This field is used if specific customers require special label formats in addition to the regularly available labels. |
Does this account use their own item codes? |
Enter Y to maintain a list of customer items, description, unit of measure, and policies. If you enter Y, press F13 to enter a list of customer items. |
Does this account require conversion to their own unit of measure? |
Enter Y to maintain a list of the preferred unit of measures by product line or item class for this account or chain. If you enter Y, press F14 to enter customer's U/M requirements. |
Does this account have special rolled goods requirement? |
Enter Y to maintain a list of the preferred roll sizes by item class or product line for this account or chain. If you enter Y, press F15 to enter the customer's rolled goods requirements. |
Send all invoices EDI. Disable printing invoices? |
Enter Y in this field if all invoices for this account or chain are transmitted via EDI and do not need to be printed. If you enter Y, the invoice print program skips invoices for this account or chain. The invoices must still be processed, but the customer receives the EDI file rather than the printed invoice. |
Does the customer require order-level, pallet level or No ASNs? |
Enter a code to designate how this account or chain should receive EDI advance shipment notices. Valid codes are:
ASNs are EDI Advance Ship Notices that inform the customer of the details of shipments being delivered to them. Set this flag only if the ASN EDI transaction sets have been set up for this trading partner. The default is N. |
Number of UCC-128 labels required on each pallet |
Enter the number of UCC-128 labels this account or chain requires on each pallet. Enter a value in this field only if the customer requires UCC-128 pallet labels. These are bar code labels that contain information regarding what is included on each pallet. The bar codes are then read by the customer's receiving system. |
Function Keys
Function Key |
Description |
F1 |
Go to the next record without going back to the Entry screen. This is helpful if you are updating or viewing record by record within the file. Press F1 to enter the current screen and then displays the next record in the file. |
F6 |
Search for customer preference numbers. |
F7 |
End the job and return to the File Maintenance Menu. |
F8 |
Return to the Customer Preferences File Entry screen. |
F10 |
Go to More Options screen. |
F13 |
Go to the Customer Preferences Item Cross Reference Screen. |
F14 |
Go to the Customer Preferences Unit of Measure (UOM) Table. |
F15 |
Go to the Customer Preferences Roll Sizes Screen. |
F16 |
You can use this screen to create 30-character messages, primarily for bar code pick labels, for items, product lines, and item classes. The messages are not cumulative. Only one of these messages is ever selected per line item. Item number (type I) messages override product line (type L) and item class (type C) level messages. Product line messages override item class messages. For more information, refer to The Customer/Item Messages Screen. |
F17 |
This function allows you to assign preferred serial numbers which tie into the Inventory Selection Optimizer (ISO) ability to assign points for preferred serial numbers. Preferred serial numbers can be specified by customer accounts, or for chain codes, which encompass multiple accounts. Additionally, a preferred serial number may be assigned based on Item Class 1 (such as glazed wall tile) or to a Product line. An assignment to a Product Line overrides an assignment to an Item Class. For more information, refer to Assigning Preferred Serial Numbers. |
To access the second set of options, press F10.
Field Name |
Description/Instructions |
Does the customer require Order-level, Pallet-level or No ASNs? |
Enter a code to designate how this account or chain would like to receive EDI advance shipment notices. Valid codes are:
ASNs are EDI Advance Ship Notices which inform the customer of the details of shipments being delivered to them. Set this flag only if the ASN EDI transaction sets have been set up for this trading partner. The default is N. |
Number of UCC-128 labels required on each pallet |
Enter the number of UCC-128 labels this account or chain requires on each pallet. Enter in this field only if the customer requires UCC-128 pallet labels. These are bar code labels that contain information regarding what is included on each pallet. The bar codes are then read by the customer's receiving system. |
Number of Copies of Printed Invoice to Regular Address |
Number of invoice copies that are printed for the Billto address. Entries of 0 - 5 are valid. This feature is designed only to work with the Print Copies of Invoice function on the Invoicing Menu. This does not apply to point-of-sale or regular batch invoice printing. |
Number of Copies of Printed Invoice to Store if applicable |
Number of invoice copies printed for the Shipto address. Entries of 0 - 5 are valid. This feature is designed only to work with the Print Copies of Invoice function on the Invoicing Menu. This does not apply to point-of-sale or regular batch invoice printing. |
Consolidate multiple invoices into single PDF for ODS |
Allows the Output Distribution System (ODS) to generate and email multiple invoices as one PDF file. If not activated, the default, a single PDF is generated and emailed for each invoice. Associated settings:
|
Print Customer Item Description on Invoice instead of Item File Desc. |
Enter Y if you want to substitute the customer's item description for the usual item file description. Otherwise, enter N. This occurs only if a customer description for the item is found for this customer or chain. Customer item descriptions are set up using the Customer Items screen, via F13. |
Default Invoice Split Code (affects sorting of invoices) |
Enter any character or number as a split code if you want this customer's invoices to be sorted to the end of all batch invoice runs. Batch invoices are sorted primarily by split code. For example, all COD accounts could be assigned split code C. The COD invoices print at the end of the batch, making it easy to identify and separate them. |
Does Customer Require Pre-Shipment Notification |
This is a special EDI transaction set for customers who require notification if a shipment a day or more sooner than an ASN (Advance Shipment Notification) is sent. Enter Y in this field only if your customer requires this feature. |
Does This Customer/Chain Use Special Customer/Item Level Messages? |
If you enter Y in this field, you can press F16 to access the The Customer/Item Messages Screen. |
Customer Currency Code For Invoices |
Invoices for the customer should be converted to an alternate currency as represented by the currency code. The currency must have a valid entry in the Currency Code/Exchange Rate Table on the System Settings Menu (SET 11). The Customer Currency Code can only be set at a customer account number level. |
Print prices on Order Acknowledgements
Totals |
Enter Y to print prices on the customer's Order Acknowledgements or N not to print the prices on the Order Acknowledgements. The default is Y. Therefore, prices remain on order acknowledgements, unless you change the setting to N. This feature is set by individual account or by chain code. Settings by individual account override settings by chain. If you are issuing order acknowledgements to customers, such as national accounts) whose pricing is controlled by a third party, consider omitting prices from their order acknowledgements. The Totals and Print prices on Order Acknowledgements settings give you the option to display different combinations of pricing on laser Order Acknowledgements. Some of the combinations can be:
These options apply only to laser acknowledgments. Line item prices and price totals will always show on impact (nonlaser printers) regardless of this setting. Reference page 3 of the Work Station Control Panel (SET 1) for details on the setup of laser acknowledgments. Additional options for Order Acknowledgments are available under the System Wide Setting (SET 4) - Options for Order Acknowledgments. Among the options available in this System Wide Setting are ones that allow you to change the title of the Order Acknowledgment and format the document as needed. |
The next three settings deal with UCC/EAN-128 Labels. A UCC-128 label is a type of label with a standardized format. The Uniform Council Code is the non-profit organization that defines various worldwide standards for bar-coding and EDI. You can learn about the UCC at www.uc-council.org. The system uses UCC-128 labels to identify a pallet. The main identification number on a UCC-128 label is the pallet ID# which is assigned to all the items within a pallet. A UCC-128 label can also be attached to non-palletized goods such as a roll or area rug. UCC-128 is also referred to as UCC/EAN 128. EAN stands for International Article Numbering, which is commonly used in Europe. |
|
Department to Print on UCC/EAN-128 Labels . |
This is typically the department code assigned by the customer you are shipping to. |
Vendor Number Assigned by Customer |
This is typically the vendor code assigned by the customer you are shipping to. |
U/M to Convert Qty to for UCC/EAN-128 Labels |
This setting uses the Packaging File to make UM conversions. This unit of measure is used only if a valid conversion factor exists on the system. |
Suppress Printing Terms on Invoices |
The setting allows you to determine, at the account level, whether or not payment terms are included on a customer's invoice. |
Customer Preference Print Options
The F2=Print Options option lets you establish Bill of Lading printing defaults.
The system supports the Voluntary Interindustry Commerce Standards (VICS) for Bills of Lading (BOLs). The objective of standardizing the Bill of Lading is to ensure that the shipper, the carrier, and the customer (the consignee) are all receiving the information they need for the processing of the goods through the supply chain. The standard VICS BOL is intended for U.S. Less Than Truck Load (LTL) and Truck Load (TL) ground transport. Included with the standard Bill of Lading form is a standard Bill of Lading number. The standard Bill of Lading form and number ensure that all key data elements are present and documented in a uniform manner.
To set up a customer to use the VICS BOL, press F2. The Forms Control File Maintenance screen appears.
Enter a U to update/establish a BOL format. There are three pages of printer settings. The setting that controls the BOL format is located on the third page.
The field that controls the BOL format is Bill of Lading Format. At the current time, there are two options:
- 6 - For a Lowes format BOL. Has a 17 digit bill of lading number. SCAC and Carrier Pro numbers are barcoded together.
- 7 - For a Home Depot format BOL. Has a 12 digit bill of lading number. SCAC and Carrier Pro numbers are barcoded individually.
Customer Preferences Item Cross Reference Screen
Use this screen to enter a customer's set of item numbers. You can also enter descriptions of the items, if you want. The customer's item number appears on pick lists and invoices along with your item number. The item number can also be transmitted on outbound EDI transmissions. You can enter up to five items per screen.
This screen is accessed by pressing the F13 on the Customer Preferences Profile Screen.
You can use the Position To field to start the list at any item number.
The following table describes the fields on this screen:
Field Name |
Description/Instructions |
Our Item Number |
Item number from the Item File. |
Their Item/Description |
Customer's item number that cross references to the Our Item Number field, followed optionally by the customer's description of the item. If you leave the description field blank, the system uses the description from the Item File. |
Pref Flag |
Enter Y to flag the preferred customer item number for this item when multiple customer items are listed. This field is applicable only when the customer has two or more item numbers that relate to the same item on your system. For example, if the customer uses item numbers 301965 and 301957 and they both relate to your item number ARB12A, then you should flag the preferred number. The item number marked with the Pref Flag Y is always the item number transmitted to the customer, although both item numbers can be received from the customer. |
Their U/M |
Code for the unit of measure in which the customer prefers to be invoiced for this item. The customer's invoices and pick list display their price and quantity converted to this unit of measure. If left blank, the system uses the unit of measure in which you invoice this item. You also have the option to set up a table of the customer's preferred units of measure by item class or product line using the Customer Preferences Unit of Measure (UOM) Table which is accessed via F14. Any U/M entered here by item overrides entries made by item or product line in the Customer Preferences UOM Table. |
Their Policies |
Optionally, enter item policy codes that override the normal policies for this item. Leave this blank to leave the Item File policies in effect. |
Customer Preferences Unit of Measure (UOM) Table
You can use this screen to translate quantities and unit prices to alternate units of measure according to your customer's preferences. Pick tickets and invoices show both the usual and the customer's unit of measure. The pick list and invoice convert quantity to the customer's unit of measure. The invoice also displays the unit price per the native unit of measure and per the customer's unit of measure. To go to this screen, press F14 on the Customer Preferences Profile Screen.
If you also specify a preferred unit of measure for a specific item number using the The Customer/Item Messages Screen via F13, then that unit of measure overrides any applicable entry on this screen.
Field Name |
Description/Instructions |
Product Type |
Enter C to indicate Item Class 1 or L to indicate product line. |
Record (?) |
If you entered C as the product type, enter an Item Class 1 code here. If you entered L as the product type, enter a product line code here including the manufacturer prefix. You can enter ? to search for either the item class or product line, based on your product type entry. |
Description |
Description of the record. |
If our U/M is: |
Native unit of measure that the customer wants to change. |
then convert to: |
Unit of measure code that the customer prefers to see on invoices for the specified item class or product line. Important: This unit of measure is used only if a valid conversion factor exists on the system. |
Customer Preferences Roll Sizes Screen
You can use this screen to set minimum, maximum, and optimal roll sizes customers that purchase rolls primarily for their own stock. This table is used by the Inventory Selection Optimizer (ISO) based on the points and rules set in the rolled goods ISO tables. The ISO Maintenance Program is accessed via the System Settings Menu. To go to this screen, press F15 on the Customer Preferences Profile Screen.
Field Name |
Description/Instructions |
Open Rolls Allowed if UM=RL? |
ISO checks for this flag. If flag is set to Y, then open or unopened rolls are considered for ISO selection. If flag is set to N, then open rolls are not considered for ISO selection. The default setting is Y. Use N for customers who require only unopened rolls when they order in full roll increments. |
Allow Best Buy Logic |
Allows you to turn off the best buy logic that ISO uses forcing order entry to order only the exact amount entered. The best buy logic for rolled goods enables ISO to favor roll balances that provide a customer with a greater or equal length of material for less than the price of a cut. |
Product Type |
Enter C to indicate Item Class 1 or L to indicate product line. |
Record (?) |
If you entered C as the product type, enter an Item Class 1 code here. If you entered L as the product type, enter a product line code here including the manufacturer prefix. You can enter a ? to search for either the item class or product line, based on your product type entry. |
Description |
Description of the record. |
Width |
Width, in inches, to which the roll sizes pertain. For example, enter 144 for 12 foot goods. |
Roll Sizes |
Roll sizes expressed in lineal feet. |
Minimum |
Minimum size roll this customer accepts on a normal stock order. |
Maximum |
Maximum size roll this customer accepts on a normal stock order. |
Optimum |
Optimum size roll for this customer on a normal stock order. |
The Customer/Item Messages Screen
You can use this screen to create 30-character messages, primarily for bar code pick labels, for items, product lines, and item classes. The messages are not cumulative. Only one of these messages is ever selected per line item. Item number (type I) messages override product line (type L) and item class (type C) level messages. Product line messages override item class messages. To go to this screen, press F16 on the Customer Preferences Profile Screen.
Field Name |
Description/Instructions |
Type C, L, I |
Enter C to create a message for all items in an item class. Enter L to create a message for all items in a product line. Enter Ito create a message for a specific item. |
Record (?) |
Enter the record number or code of the item class, product line, or item for which you are creating a message. For example, if you entered an I as the type, enter the item number in this field. You can enter a ? to search for the file corresponding to your type entry. |
Desc |
Once an entry is created, the description of the item class, product line, or item displays in this field. |
Message |
Enter the message that will print on the picking document for the specified products. |
Print on Pick List |
Enter Y to print the message on picking lists. |
Print on Pack List |
Enter Y to print the message on packing lists. |
Print on Pick Label |
Enter Y to print the message on pick labels. |
Press F11 - Alternate View to display the entire product description beneath the Message field.
Assigning Preferred Serial Numbers
Pressing F17 on the Customer Preference Table Maintenance screen allows you to assign preferred serial number for a specific customer. This functionality works in conjunction with the Inventory Selection Optimizer (ISO) to assign points for preferred serial numbers.
Preferred serial numbers can be specified by customer accounts, or for chain codes, which encompass multiple accounts. Additionally, a preferred serial number may be assigned based on Item Class 1 (such as glazed wall tile) or to a Product line. An assignment to a Product Line overrides an assignment to an Item Class.
On the Customer Preference Table Maintenance screen, press F17=Pref S/N to assign preferred serial number. The screen that appears allows you to assign preferred serial numbers for a specific customer. Assigning serial numbers to a chain code uses the same screen and process.
Note If no serial numbers are established within the Customer Preference File, ISO performs the inventory selection process as normal. The exception to this is if the Use Last Ser# Shipped as Pref Ser#, if no Pref Ser# Found field is activated via screen 5 of the ISO process (Menu ISO, option 1). Then the last serial number that was shipped for that product to the customer would be treated like it was the preferred serial number and would be allocated if available.
The fields on this screen are described in the following table.
Field |
Description |
Product Type C or L |
Enter a C for item class 1 products and a L for product line products. |
Record(?) |
Enter the product line or item class 1 record you want to attached to a serial number. Enter a ? in the field to display all the available product lines or item classes. |
Preferred Serial# |
Enter the preferred serial number for the product line or item class. After these settings are made, when this customer orders an item class or product line that has been set-up with a preferred serial number, ISO tries to match serial numbers. If an exact match cannot be found, ISO finds the best substitute based on your input. Items must be in inventory to be considered in the selection process. |
Using the settings shown above, if this customer orders items in either product line FLTPOC or REXECO the system, via ISO, attempts to allocate products that closely match the assigned serial number.
Associated Files
- Billto File - FIL 1
- Customer Special Price File - FIL 18
- Retail Customer File - FIL 60
- Options for Customer Search
- Customer Search File - INQ 1